The documentation for the %MDSECDS security reporting macro states that you can use the MEMBERTYPES= parameter to limit the output by object type. This implies that only objects of the type specified are included in the output from the macro.

However, due to the way the object metadata is retrieved, the output will also contain authorization information for all child objects that make up the requested object type. Some examples of objects that have such child object associations are Table and Cube objects. For example, if you request MEMBERTYPES="Table", you will also receive authorization information for Column objects. If you request MEMBERTYPES="Cube", you will also see information for Level, Dimension, and Hierarchy objects.

To omit the authorization information for the additional objects, you can work around this problem by further subsetting the output data set, or view by including a WHERE clause similar to the following in the code you use to generate the report listing:

or...

Also refer to SAS Note 35778 for a similar problem relating to additional Folder objects.

Operating System and Release Information